select
	r.*,
	b.realName buyerRealName,
	case
	    when
	        upper(b.device) like '%IPHONE%'
	            then 'iOS'
	    else
	        'Android'
	end platform,
	s.realName sellerRealName
from
	t_stl_jy r
left join t_stl_account b on r.buyerMobile = b.mobile
left join t_stl_account s on r.sellerMobile = s.mobile
